To set a tcp ip address and port to single or multiple nodes , append a node identification bitmap an affinity mask in brackets after the port number 若要将tcp / ip地址和端口设置到一个或多个节点,请在端口号后用括号追加一个节点标识位图(关联掩码) 。
To configure sql server to use software non - uniform memory access soft - numa , you must edit the registry to add a node configuration affinity mask 若要将sql server配置为使用软件非一致性内存访问(软件numa ) ,必须编辑注册表以添加节点配置关联掩码。
When using hardware based non - uniform memory access numa and the affinity mask is set , every scheduler in a node will be affinitized to its own cpu 当使用基于硬件的非一致性内存访问( numa )并设置了关联掩码时,节点中的每个计划程序都将关联到它自己的cpu 。
To cover more than 32 cpus , configure a four - byte affinity mask for the first 32 cpus and up to a four - byte affinity64 mask for the remaining cpus 若要涵盖32个以上的cpu ,可为前32个cpu配置一个4字节关联掩码,为其余的cpu配置一个最多4字节的affinity64掩码。
Changes to the affinity masks occur dynamically , allowing for on - demand startup and shutdown of the cpu schedulers that bind process threads within sql server 关联掩码的更改是动态进行的,因此可以按需启动和关闭用于在sql server中绑定进程线程的cpu计划程序。
This scheduler is bound to the processors in the modified affinity mask and should not put any load on the processor it was affinitized with before the change 此计划程序将被绑定到修改后的关联掩码中的处理器,在修改之前,不应在其关联的处理器上添加任何负荷。
If you specify an affinity mask that attempts to map to a nonexistent cpu , the reconfigure command reports an error message to both the client session and the sql server error log 如果指定的关联掩码试图映射到不存在的cpu , reconfigure命令会向客户端会话和sql server错误日志报告一条错误消息。
If sql server is configured to use only some of the available processors on the server , this configuration can mean that some schedulers are mapped to processors that are not in the affinity mask 如果将sql server配置为只使用服务器中某些可用的处理器,那么此配置可以表示某些计划程序被映射到不在关联掩码中的处理器。
If a specified affinity mask violates the licensing policy during sql server startup or during database attach , the engine layer will complete the startup process or database attach restore operation , and then it will reset the 如果在sql server启动期间或在数据库附加期间,指定的关联掩码违反了许可策略,则引擎层将会完成启动进程或数据库附加/还原操作,然后将关联掩码的
When the affinity mask is not set , each scheduler is affinitized to the group of cpus within the numa node and a scheduler mapped to numa node n1 can schedule work on any cpu in the node , but not on cpus associated with another node 未设置关联掩码时,每个计划程序都关联到numa节点内的cpu组,映射到numa节点n1的计划程序可针对节点中的任何cpu计划工作,但是不针对与其他节点关联的cpu计划工作。